/*insert 테스트 레벨*/
insert into level_e(level_no,level_point,day_point) values(0,0,0);
insert into level_e(level_no,level_point,day_point) values(1,50,30);
insert into level_e(level_no,level_point,day_point) values(2,120,50);
insert into level_e(level_no,level_point,day_point) values(3,200,80);
insert into level_e(level_no,level_point,day_point) values(4,330,100);
insert into level_e(level_no,level_point,day_point) values(5,500,150);
insert into level_e(level_no,level_point,day_point) values(6,650,200);
insert into level_e(level_no,level_point,day_point) values(7,850,300);
insert into level_e(level_no,level_point,day_point) values(10,0,0);

/*insert Member*/
insert into Member_e(id,password,ssn,nick,name,address,tel)
	values('java','1234','910517','java','이자바','판교','01012341324');
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('ajax','1234','890317','ajax','에젝스','판교','01012121212',3);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('jstl','1234','880417','jstl','젵티엘','판교','01012341324',5);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('spring','1234','520427','spring','수푸림','판교','01012341324',5);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('anotation','1234','830819','anotation','어놑해','판교','01012341324',5);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('json','1234','830428','json','제이순','판교','01012341324',5);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('jquery','1234','901111','jquery','잭훼리','판교','01012341324',7);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('tiles','1234','730912','tiles','타일즈','판교','01012341324',7);
insert into Member_e(id,password,ssn,nick,name,address,tel,level_no)
	values('mybatis','1234','730911','mybatis','마밭수','판교','01012341324',7);	

/*insert 레벨별 테스트 문제*/
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'What do I like to do with my friends?','On my day off I like to get up late 
and have a big breakfast. After that I often go shopping at the supermarket where I buy my weekly 
groceries. Sometimes in the afternoon I will meet my friends for coffee and a chat but these days 
they have very little free time. In the evening I cook dinner for my family and do some housework until 
about eight o clock then I like to sit down in front of the television and watch a movie. I usually go to 
bed quite late.','on my day off','get up late','have coffee and chat','cook dinner',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'What happened the day after Christmas 2004?','The day after Christmas 2004, 
a number of large waves, a Tsunami, hit beaches around the Indian Ocean. In minutes, many buildings were 
destroyed and thousands of people died. A large undersea earthquake made these big waves which then 
traveled at about 500 miles per hour until they reached land.','500 miles per hour','in minutes','thousands of people died',
'people hit the beaches',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'What does the giraffe like to eat?','A giraffe is an animal from Africa. It has a 
very long neck. It eats leaves high in the trees. It is a very tall and very quiet animal.','necks','Africa',
'leaves','quiet',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'Where do we eat dinner?','My friend and I eat dinner at the restaurant.',
'we eat dinner','my friend and I','at the restaurant','at home',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'Where is Marys house?','Mary lives in an old house in the city.'
,'with Mary','in the old house','in the city','Marys house',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'His last name is _____ .','LAST NAME: Hansen FIRST NAME: Mike BIRTHDAY: 
3 December 1974 ADDRESS: 22 Apple Street, Chicago, 00015','December','Hansen','birthday','Mike',3)
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) 
values (question_seq.nextval,7,'다음중 틀린것을 고르세요','what your name?',
'p','s','a','bruce',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) 
values (question_seq.nextval,7,'다음중 틀린것을 고르세요','im sorry',
'im fine','bye','see you later','hello',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,7,'다음중 정답을 고르세요','where are you?',
'hi','bye','spring','home',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,7,'다음중 정답을 고르세요','springframework',
'di','ioc','mvc','javase',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'His last name is _____ .','LAST NAME: Brown FIRST NAME: John AGE: 33 
COUNTRY: America JOB:singer','33','Brown','singer','America',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 정답을 고르시오','1. Could you tell me your surname?','Would you like me 
to spell it?','Do you like my family name?','How do I say that?','teacher',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'Jenny is from _____ .','LAST NAME: Smith FIRST NAME: Jenny AGE: 25 
COUNTRY: England JOB: teacher','25','England','Jenny','Smith',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 정답을 고르시오','This plant looks dead.','Its in the garden.',
'It only needs some water.','Its sleeping.','England',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 정답을 고르세요','Are you going to come inside soon?','For ever.',
'Not long.','In a minute.','worldcup',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 정답을 고르세요','Shall we go out for pizza tonight?','I know that.'
,'Its very good.','Im too tired.','brazil',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 정답을 고르세요','Do you mind if I come too?','Thats fine!','Id like to.'
,'I dont know if I can.','germany',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 틀린것을 고르세요','starcraft?',
'terran','protoss','zerg','zigs',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,6,'다음중 틀린것을 고르세요','abcd',
'efgh','a','b','c',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) 
values (question_seq.nextval,6,'다음중 틀린것을 고르세요','leageoflegend',
'제이스','제라스','제라툴','말파이트',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer)
values (question_seq.nextval,6,'다음중 틀린것을 고르세요','english',
'돼지','피그','제주도','pig',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','Theres someone at the door.','Can I help you?',
'Well, go and answer it then.','Hes busy at the moment.','swith',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','How much butter do I need for this cake?'
,'Id like one.','Ill use some.','Im not sure.','england',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','would you like something?'
,'drink.','sorry.','bye.','good',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','How long are you here for?','Since last week.'
,'Ten days ago.','Till tomorrow.','belgium',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','Have you guys had enough to eat?',
'Thats all right.','Is there any more rice?','Its not the right time.','argentina',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,5,'다음중 정답을 고르세요','Thats my coat over there.',
'Will you take it off?','No, you havent!','Here you are.','portugal',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','Lets go by bus.',
'The train was expensive.','Well buy a ticket.','Itll take too long.','korea',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','Do you know my brother Charlie?'
,'Sorry, hes not here.','I dont think I do.','I know.','japan',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','music',
'rock','ballaed','hiphop','blacksheepwall',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,5,'다음중 정답을 고르세요','project',
'why','where','all','spring',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,5,'다음중 정답을 고르세요','cheat',
'operationcwal','poweroverwhelming','showmethemoney','?',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','15. Would you like some ice in your drink or not?',
'I hope so.','Yes, I shall.','I dont mind.','austraila',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','When can we meet again?'
,'When are you free?','It was two days ago.','Can you help me?','drogba',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 틀린것을 고르세요','dog?'
,'Chihuahua','Maltese.','Shih Tzu','seven',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','where are you from?',
'bug','toilet','hi','korea',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'밑줄친 I가 가르키는것은?','I am one of the smartest animals.
I have two long ears.I work for people.I pull a cart.I look similar to a horse.What am I?',
'zebea','rabbit','giraffe','whale',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','When do you study?'
,'at school','in the evenings','in the library','showmethemoney',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','Would you prefer lemonade or orange juice?',
'Have you got anything else?','If you like.','Are you sure about that?','goodbye',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요',' Lets have dinner now.',
'You arent eating.','There arent any.','Tom isnt here yet','good',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','The snow was ...... heavily when I left the house.',
'dropping','landing','falling','descending',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요',' I cant find my keys anywhere - I ...... have left them at work.',
'can','must','ought','would',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요','When a car pulled out in front of her, Jane did well not to ...... 
control of her bicycle.','miss','lose','fail','drop',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,4,'다음중 정답을 고르세요',' According to Richards ...... the train leaves at 7 oclock.',
'opinion','advice','knowledge','information',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요',' When you stay in a country for some time you get used to the peoples ...... of life.'
,'habit','custom','way','system',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,3,'다음중 정답을 고르세요','The builders are ...... good progress with the new house.'
,'getting','doing','making','taking',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요','She is now taking a more positive ...... to her studies and should do well.'
,'attitude','behaviour','manner','style',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요','My father ...... his new car for two weeks now.',
'has had','has','is having','had',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요','What differences are there ...... the English spoken in the UK and the English spoken in the US?'
,'among','between','between','between',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요','At 6 p.m. I started to get angry with him because he was late ......'
,'as usual.','in general.','typically.','usually.',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요','16. ...... you get your fathers permission, Ill take you skiing next weekend.'
,'Although','Provided','As','Unless',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요',' A local company has agreed to ...... the school team with football shirts.'
,'contribute','supply','give','produce',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,3,'다음중 정답을 고르세요','I really enjoy stories that are ...... in the distant future.'
,'found','set','put','placed',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,3,'다음중 정답을 고르세요',' That old saucepan will come in ...... when we go camping.'
,'convenient','fitting','fitting','suitable',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,2,'다음중 정답을 고르세요',' Anyone ...... after the start of the play is not allowed in until the interval.'
,'arrives','has arrived','arriving','arrived',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요','I didnt ...... driving home in the storm so I stayed overnight in a hotel.'
,'fancy','desire','prefer','want',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요','The judge said that those prepared to...... in crime must be ready to suffer the consequences.'
,'involve','engage','undertake','enlist',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요','Marianne seemed to take ...... at my comments on her work.'
,'annoyance','insult','offence','indignation',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요',' You should not have a dog if you are not ...... to look after it.'
,'prepared','adapted','arranged','decided',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요','The farmhouse was so isolated that they had to generate their own electricity ......'
,'current.','supply.','grid.','power.',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요',' I hope I havent ...... you any trouble by changing the arrangements.'
,'put','caused','made','done',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요','When you come to my house, ...... your camera with you.'
,'take','show','fetch','bring',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요',' The floor is wet: dont run or you might ...... !',
'stoop','spill','slip','spin',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,2,'다음중 정답을 고르세요',' Paul arrived at the shop ....... as the manager was closing for the day.'
,'even','just','still','right',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','I would ...... to stay at home and relax for a change.'
,'rather','better','prefer','enjoy',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','Is there ...... of food for everyone?'
,'adequate','enough','sufficient','plenty',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,1,'다음중 정답을 고르세요','Lily says shes happy at school but shes ...... complaining.'
,'rarely','sometimes','always','often',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','. ...... the step when you go in.'
,'Consider','Mind','Attend','Look',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer)
values (question_seq.nextval,1,'다음중 정답을 고르세요','...... stay the night if its too difficult to get home.'
,'At all costs','By all means','In all','On the whole',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','No ...... Hannah is happy when you think how many prizes she has won recently.'
,'surprise','problem','question','wonder',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','hello'
,'안녕','집','학원','pc방',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 정답을 고르세요','how old are you?'
,'32','h','a','c',3);
insert into question_e(question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values
(question_seq.nextval,1,'다음중 정답을 고르세요','집',
'home','h','o','m',3);
insert into question_e (question_no,level_no,title,content,ex1,ex2,ex3,ex4,answer) values 
(question_seq.nextval,1,'다음중 옳은것을 고르시오','Many people find Japanese culture and 
traditions fascinating and want to find out more about them. Reading 
about local traditions and talking to local people is one way to do 
this. Another way is to take Japanese culture classes at university 
or employ a local tutor to teach you at home.','(1) a local 
tutor','(2) talking to local people','(3) it s very 
interesting','(4) read about local traditions',4);

select * from question_e;



